SELECT sername,
name,
email,
telephone,
`1.1`,
`1.2`,
`1.3`,
`father`.profession AS`father`,
`mather`.profession AS `mather` ,
`1.5`,
`2.1_math`,
`2.1_phisics`,
`2.1_informat`,
`2.1_him`,
`2.1_bio`,
`2.1_gegrafy`,
`2.1_russian`,
`2.1_liter`,
`2.1_inostr`,
`2.1_history`,
`2.1_obshestvo`,
`2.1_pravo`,
`2.1_cherchenie`,
`2.1_mir kyltyra`,
`2.1_tehnologia`,
`2.1_fizkyltyra`,
olimpiads.nazvanie AS olimpiads,
`2_3`.nazvanie AS `2.3`,
`2.4`.nazvanie AS `2.4`,
`3.1`.nazvanie AS `3.1`,
`3_4`.nazvanie AS `3.4`,
`3.5`.profession AS `3.5`,
`3.6`.nazvanie AS `3.6`,
`3.7`.nazvanie AS `3.7`,
`3_8`.nazvanie AS `3.8`,
`3_9`.nazvanie AS `3.9`,
`3_10`.nazvanie AS `3.10`,
`3.110`.nazvanie AS `3.110`, 
`3.111`.nazvanie AS `3.111`,
`3.112`.nazvanie AS `3.112`,
`3.120`.nazvanie AS `3.120`,
`3.121`.nazvanie AS `3.121`,
`4.1`.NAZVANIE AS `4.1`,
`4.2`.NAZVANIE AS `4.2`,
`4.3`.nazvanie AS `4.3`,
`4.4`.nazvanie AS `4.4`,
`4.5`.nazvanie AS `4.5`,
`5.1`.nazvanie AS `5.1`,
`5.2`.nazvanie AS `5.2`,
`5.3`.nazvanie AS `5.3`,
`5.4`.nazvanie AS `5.4`,
`6.10`.nazvanie AS `6.10`,
`6.11`.nazvanie AS `6.11`,
`6.2`.nazvanie AS `6.2`,
`7.1k`.nazvanie AS `7.1k`,
`7.1s`.nazvanie AS `7.1s`,
`7.1n`.nazvanie AS `7.1n`,
`7.2k`.nazvanie AS `7.2k`,
`7.2s`.nazvanie AS `7.2s`,
`7.2n`.nazvanie AS `7.2n`,
`7.3`.nazvanie AS `7.3`,
`7.4`.nazvanie AS `7.4`,
`8.1`.nazvanie AS `8.1`,
`8.2`.nazvanie AS `8.2`,
`8.3`.nazvanie AS `8.3`,
`vyhod`.nazvanie AS `vyhod`
FROM result,
`1_4` AS `father`,
`1_4` AS `mather`,
`da_chastichno_net` AS olimpiads,
`2_3`,
`da_chastichno_net` AS `2.4`,
`da_chastichno_net` AS `3.1`,
`3_4`,
`1_4` AS `3.5`,
`da_chastichno_net` AS `3.6`,
`da_chastichno_net` AS `3.7`,
`3_8`,
`3_9`,
`3_10`,
`3_11` AS `3.110`,
`3_11` AS `3.111`,
`3_11` AS `3.112`,
`3_11` AS `3.120`,
`3_11` AS `3.121`,
`da_chastichno_net` AS `4.1`,
`da_chastichno_net` AS `4.2`,
`da_chastichno_net` AS `4.3`,
`da_chastichno_net` AS `4.4`,
`4_5` AS `4.5`,
`5_1` AS `5.1`,
`da_chastichno_net` AS `5.2`,
`da_chastichno_net` AS `5.3`,
`da_chastichno_net` AS `5.4`,
`6_1` AS `6.10`,
`6_1` AS `6.11`,
`6_2` AS `6.2`,
`da_chastichno_net` AS `7.1k`,
`da_chastichno_net` AS `7.1s`,
`da_chastichno_net` AS `7.1n`,
`da_chastichno_net` AS `7.2k`,
`da_chastichno_net` AS `7.2s`,
`da_chastichno_net` AS `7.2n`,
`da_chastichno_net` AS `7.3`,
`da_chastichno_net` AS `7.4`,
`da_chastichno_net` AS `8.1`,
`da_chastichno_net` AS `8.2`,
`8_3` AS `8.3`,
`vyhod`AS `vyhod`
WHERE `1.4f`=`father`.id AND 
`1.4m`=`mather`.id AND 
`2.3`=`2_3`.id AND
olimpiads.id=`2.2` AND
`2.4`.id=`2.4` AND
`3.1`.ID=`3.1` AND
`3_4`.ID=`3.4` AND
`3.5`.ID=`3.5` AND
`3.6`.ID=`3.6` AND
`3.7`.ID=`3.7` AND
`3_8`.ID=`3.8` AND
`3_9`.ID=`3.9` AND
`3_10`.ID=`3.10` AND
`3.110`.ID=`3.110` AND
`3.111`.ID=`3.111` AND
`3.112`.ID=`3.112` AND
`3.120`.ID=`3.120` AND
`3.121`.ID=`3.121` AND
`4.1`.ID=`4.1` AND
`4.2`.ID=`4.2` AND
`4.3`.ID=`4.3` AND
`4.4`.ID=`4.4` AND
`4.5`.ID=`4.5` AND
`5.1`.ID=`5.1` AND
`5.2`.ID=`5.2` AND
`5.3`.ID=`5.3` AND
`5.4`.ID=`5.4` AND
`6.10`.ID=`6.10` AND
`6.11`.ID=`6.11` AND
`6.2`.ID=`6.2`AND
`7.1k`.Id=`7.1k`AND
`7.1s`.Id=`7.1s`AND
`7.1n`.Id=`7.1n`AND
`7.2k`.Id=`7.2k`AND
`7.2s`.Id=`7.2s`AND
`7.2n`.Id=`7.2n`AND
`7.3`.Id=`7.3`AND
`7.4`.Id=`7.4`AND
`8.1`.Id=`8.1`AND
`8.2`.Id=`8.2`AND
`8.3`.Id=`8.3`AND
`vyhod`.Id=`vyhod`